#[[###]]##(comment)基础查询
#[[#sql("list")]]#
	SELECT
		`#(tableName)`.*
		#for(item : columns)
			#if(item.queryType=='dictionarySelect')
				,getDictionaryDesc('#(item.dictionaryTypeId)',`#(tableName)`.#(item.name)) as #(item.name)Desc
			#end
		#end
	FROM
		#(tableName) AS `#(tableName)`
	WHERE 1=1
		#[[#@]]##(beanName)Wheres()
		#[[#@]]##(beanName)Orderby()
#[[#end]]#

#[[#define]]# #(beanName)Wheres()
	#[[#if]]#(id)
		AND `#(tableName)`.#(primaryName)=#[[#para]]#(id)
	#[[#end]]#

	#for(item : columns)
		#if(item.queryType=='jqcx' || item.queryType=='dictionarySelect')
			#[[#if]]#(#(item.name))
				AND `#(tableName)`.#(item.name)=#[[#para]]#(#(item.name))
			#[[#end]]#
		#else if(item.queryType=='like')
			#[[#if]]#(#(item.name))
				AND `#(tableName)`.#(item.name) #paraLike(#(item.name))
			#[[#end]]#
		#end
	#end
#[[#end]]#

#[[#define]]# #(beanName)Orderby()
	#[[#if]]#(prop)
		order by `#(tableName)`.#[[#]]#(prop) #[[#(sort)]]#
	#[[#end]]#
#[[#end]]#